--SYSTEM CATALOG COMMANDS

SELECT VIEW_NAME
FROM USER_VIEWS;


SELECT *
FROM USER_TAB_COLUMNS;


SELECT COLUMN_NAME, DATA_TYPE
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'STUDENT';


DESCRIBE STUDENT;

DESCRIBE HISTMAJ;

DESCRIBE USER_CONSTRAINTS;


SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME
FROM USER_CONSTRAINTS;


SELECT TRIGGER_NAME,  TRIGGER_TYPE
FROM USER_TRIGGERS; 
